﻿using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.Data.SqlClient;


namespace DAL
{
    /// <summary>
    /// Summary description for DA_GD_NGANH_TRUNG
    /// </summary>
    public class DA_GD_NGANH_TRUNG : DbObject
    {
        protected SqlConnection connec;
        public DA_GD_NGANH_TRUNG(SqlConnection Connection)
        {
            connec = Connection;
            //
            // TODO: Add constructor logic here
            //
        }
        public DataSet load_danh_sach_nganh_trung(int i_id_gd_nganh_trung)
        {
            SqlParameter[] parameters =  {	
                                             new SqlParameter("@ID_NGANH_THUOC_TRUONG", SqlDbType.Int,4) ,                              
										 };
            // set the 0values
            parameters[0].Value = i_id_gd_nganh_trung;
            // create the parameter
            DataSet ds_dm_truong = RunProcedure("sp_Dm_nganh_trung", parameters, "V_GD_NGANH_TRUNG", connec);
            return ds_dm_truong;
        }
    }
}